A complementary algorithm based on omni - sequential scan algorithm 順序掃描的補充算法
Access plan directives that force the optimizer to use the designated access method for data retrieval , either sequential scan or index scan 訪問計劃指示,強制優化器使用指定的訪問方法進行數據檢索,要么是連續掃描,要么是索引掃描。
The above example shows that sequential scan and indexes are used to do the data retrieval , and the nested - loop join method is used to join all tables 以上示例展示了如何使用連續掃描和索引來進行數據檢索,以及如何使用嵌套循環連接方法來連接所有表。